<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<meta http-equiv="Content-Style-Type" content="text/css" />
				<title>1.8&#xa0;&#xa0;&#xa0; SQL编辑器</title>
		<link href="xcloud-sqldeveloper-helper.css" type="text/css" rel="stylesheet" />
	</head>
	<body><h2 style="margin-left:0pt; text-indent:0pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8</span><span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span><a name="_Toc443396601">SQL编辑器</a></h2>
			<p>SQL编辑器用于编辑和执行SQL。使用SQL编辑器可以通过SQL命令的方式与行云服务器进行交互。</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.1</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396602">打开SQL编辑器</a></h3>
			<p style="line-height:150%; font-size:10.5pt">打开sql编辑器,首先要成功建立连接，它有两个入口:</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">第一是在工具栏中单击<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.157.jpg" width="27" height="29" alt="" />;</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">第二是右键连接单击SQL编辑器,</p>
			<p style="line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.158.jpg" width="295" height="341" alt="" />
			</p>
			<ol start="3" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">点击菜单栏</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器，单击</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">新建</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮</span></li>
			</ol>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">     <img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.159.jpg" width="402" height="262" alt="" /></p>
			<p style="line-height:150%; font-size:10.5pt">打开编辑界面,输入一条sql语句,在数据表中会查询出结果,如下图所示</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.160.jpg" width="597" height="531" alt="" />
			</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.2</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396603">执行SQL语句</a></h3>
			<p style="line-height:150%; font-size:10.5pt">执行SQL语句时，如在同一编辑器内有多条SQL语句，可选中其中一条执行，如下图所示</p>
			<p style="line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.161.jpg" width="598" height="174" alt="" />
			</p>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">&#xa0;</p>
			<p style="line-height:150%; font-size:10.5pt">如不选中一条，则按先后顺序执行。</p>
			<p style="line-height:150%; font-size:10.5pt">执行sql语句的入口是:</p>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">    一、工具栏中<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.162.jpg" width="28" height="29" alt="" />图标，</p>
			<ol start="2" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; text-align:left; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">菜单栏</span><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器中的</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">执行</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮</span><span style="font-family:Calibri; font-size:10.5pt">,</span></li>
			</ol>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.159.jpg" width="402" height="262" alt="" />
			</p>
			<ol start="3" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; text-align:left; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器中右键</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">执行</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮：</span></li>
			</ol>
			<p style="text-indent:0pt; text-align:left; line-height:150%; font-size:10.5pt">    <img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.163.jpg" width="222" height="243" alt="" /></p>
			<p style="text-indent:0pt; text-align:left; line-height:150%; font-size:10.5pt"> 四、快捷键F8</p>
			<p style="text-indent:0pt; text-align:left; line-height:150%; font-size:10.5pt">执行结果如图所示:</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">执行中：</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.164.jpg" width="598" height="413" alt="" />
			</p>
			<p style="text-indent:0pt; text-align:left; line-height:150%; font-size:10.5pt">&#xa0;</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">执行成功：</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.165.jpg" width="598" height="497" alt="" />
			</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.3</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396604">终止SQL语句</a></h3>
			<p>终止SQL语句的入口：</p>
			<ol type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器中右键</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">停止</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮：</span></li>
			</ol>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.166.jpg" width="222" height="243" alt="" />
			</p>
			<p>二、点击执行过程中下图中的红色按钮<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.167.jpg" width="17" height="15" alt="" />：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.168.jpg" width="587" height="226" alt="" />
			</p>
			<p>终止成功：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.169.jpg" width="598" height="406" alt="" />
			</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.4</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396605">显示行号</a></h3>
			<p>右键SQL编辑器左侧栏，选中 “显示行号”，就会在侧栏出现行号，如图：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.170.jpg" width="598" height="298" alt="" />
			</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.5</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396606">括号匹配</a></h3>
			<p>在SQL输入中，当光标在括号左右时，与之对应的括号，会自动黑框选中，如图：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.171.jpg" width="598" height="113" alt="" />
			</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.6</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396607">SQL格式化</a></h3>
			<p style="line-height:150%; font-size:10.5pt">SQL格式化的入口是：</p>
			<ol type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside">
					<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.172.jpg" width="35" height="28" alt="" style="margin:0pt 9pt; float:left" /><span style="font-family:宋体; font-size:10.5pt">点击工具栏进行格式化</span></li>
			</ol>
			<p style="text-indent:0pt; text-align:left; line-height:150%; font-size:10.5pt">               二、菜单栏SQL编辑器中的 “SQL美化” 按钮：</p>
			<p style="margin-left:21pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.159.jpg" width="402" height="262" alt="" />
			</p>
			<ol start="3" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器中右键</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">美化</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮：</span></li>
			</ol>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">    <img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.163.jpg" width="222" height="243" alt="" /></p>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">格式化结果如图：</p>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.173.jpg" width="598" height="142" alt="" />
			</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.7</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396608">输出执行结果</a></h3>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.7.1<span style="font:7.0pt 'Times New Roman'"> </span> 展示界面</h4>
			<p style="line-height:150%; font-size:10.5pt">当执行完一条sql语句时，会在表格中展示出执行完sql语句的结果集，并且返回执行时间、显示行数和总记录数。如下图所示</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.174.jpg" width="598" height="323" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.7.2<span style="font:7.0pt 'Times New Roman'"> </span> 排序</h4>
			<p style="line-height:150%; font-size:10.5pt">单击表格列名进行排序，列后箭头向下为降序，向上则为升序。单击位置如图所示</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.175.jpg" width="400" height="23" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.7.3<span style="font:7.0pt 'Times New Roman'"> </span> 分页</h4>
			<p>分页在查询结果栏中：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.176.jpg" width="597" height="214" alt="" />
			</p>
			<p>点击<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.177.jpg" width="30" height="24" alt="" /> 为追加显示下一页的记录</p>
			<p>点击<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.178.jpg" width="25" height="24" alt="" /> 为追加显示所有记录</p>
			<p>&#xa0;</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.7.4<span style="font:7.0pt 'Times New Roman'"> </span> 查看和复制</h4>
			<p style="line-height:150%; font-size:10.5pt">查看结果集中单元格里面的内容时，双击想要查看的内容单元格，弹出一个对话框，对话框里面展示了单元格的内容，如图：</p>
			<p style="line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.179.jpg" width="424" height="500" alt="" />
			</p>
			<p style="line-height:150%; font-size:10.5pt">复制对话框里面的内容时，右键进行复制，如下图所示</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.180.jpg" width="235" height="72" alt="" />
			</p>
			<p>&#xa0;</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.7.5<span style="font:7.0pt 'Times New Roman'"> </span> 导出结果集</h4>
			<p style="line-height:150%; font-size:10.5pt">执行完sql语句后,导出结果集到本地,入口是：</p>
			<p style="line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.181.jpg" width="30" height="32" alt="" style="margin:0pt 9pt; float:left" />一、工具栏中的图标,点击该图标</p>
			<ol start="2" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">菜单栏</span><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器中的</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:宋体; font-size:10.5pt">导出</span><span style="font-family:Calibri; font-size:10.5pt">CVS</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮</span></li>
			</ol>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.159.jpg" width="402" height="262" alt="" />
			</p>
			<ol start="3" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:Calibri; font-size:10.5pt">SQL</span><span style="font-family:宋体; font-size:10.5pt">编辑器右键</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">导出</span><span style="font-family:Calibri; font-size:10.5pt">csv</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮：</span></li>
			</ol>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.163.jpg" width="222" height="243" alt="" />
			</p>
			<p style="line-height:150%; font-size:10.5pt">点击后弹如下图所示对话框</p>
			<p style="line-height:150%; font-size:10.5pt">&#xa0;</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.182.jpg" width="487" height="216" alt="" />
			</p>
			<p><span style="font-size:11pt">添加记录数，点击确定，弹出如图所示的对话框：</span></p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.183.jpg" width="598" height="398" alt="" />
			</p>
			<p><span style="font-size:11pt">选择保存路径，点击保存，结果接导出成功：如图所示</span></p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.184.jpg" width="90" height="91" alt="" />
			</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.8</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396609">执行计划</a></h3>
			<p>执行计划的入口是(代理模式下)：工具栏中的<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.185.jpg" width="28" height="23" alt="" />，如图：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.186.jpg" width="384" height="176" alt="" />
			</p>
			<p>点击后会生成执行计划如下：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.187.jpg" width="400" height="220" alt="" />
			</p>
			<p>选中图中的节点右键对执行计划进行操作：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.188.jpg" width="349" height="278" alt="" />
			</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:71.45pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.9</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396610">打开sql文件</a></h3>
			<p>打开sql文件的入口是:菜单栏中的 “文件” 按钮中的 “打开文件”按钮：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.192.jpg" width="437" height="281" alt="" />
			</p>
			<p>点击后出现以下弹出框：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.193.jpg" width="598" height="393" alt="" />选择sql文件并点击 “打开” 按钮。</p>
			<h3 style="margin-left:42.55pt; text-indent:-42.55pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.10</span><span style="font:7.0pt 'Times New Roman'"> </span><a name="_Toc443396611">保存</a></h3>
			<p>保存的入口：</p>
			<ol type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:0pt; text-indent:21pt; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">菜单栏中的</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">文件</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:Calibri; font-size:10.5pt"> </span><span style="font-family:宋体; font-size:10.5pt">按钮中的</span><span style="font-family:宋体; font-size:10.5pt"> </span><span style="font-family:Calibri; font-size:10.5pt">“</span><span style="font-family:宋体; font-size:10.5pt">保存</span><span style="font-family:Calibri; font-size:10.5pt">”</span><span style="font-family:宋体; font-size:10.5pt">按钮，也可使用其快捷键</span><span style="font-family:Calibri; font-size:10.5pt">Ctrl+S</span><span style="font-family:宋体; font-size:10.5pt">：</span></li>
			</ol>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.192.jpg" width="437" height="281" alt="" />
			</p>
			<p>二、在SQL编辑器中右键：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.163.jpg" width="222" height="243" alt="" />
			</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">首次保存时，会提示确定保存路径，输入文件名，并点击保存：</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.194.jpg" width="598" height="386" alt="" />
			</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt"><span style="font-family:宋体">&#xa0;</span></p>
			<h3 style="margin-left:42.55pt; text-indent:-42.55pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.11</span><span style="font:7.0pt 'Times New Roman'"> </span><a name="_Toc443396612">另存为</a></h3>
			<p>保存的入口为：菜单栏中的 “文件” 按钮中的 “另存为”按钮：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.192.jpg" width="437" height="281" alt="" />
			</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">点击会提示确定保存路径，输入文件名，并点击保存：</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.194.jpg" width="598" height="386" alt="" />
			</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:42.55pt; text-indent:-42.55pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.12</span><span style="font:7.0pt 'Times New Roman'"> </span><a name="_Toc443396613">打印</a></h3>
			<p>打印的入口为：菜单栏中的 “文件” 按钮中的 “打印”按钮：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.192.jpg" width="437" height="281" alt="" />
			</p>
			<p>&#xa0;</p>
			<p>&#xa0;</p>
			<p style="text-align:left; line-height:150%; font-size:10.5pt">点击打印，会打印出编辑器中的SQL语句：</p>
			<p>
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.195.jpg" width="497" height="402" alt="" />
			</p>
			<h3 style="margin-left:42.55pt; text-indent:-42.55pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.13</span><span style="font:7.0pt 'Times New Roman'"> </span><a name="_Toc443396614">编辑</a></h3>
			<h4 style="margin-left:57.4pt; text-indent:-57.4pt">1.8.13.1<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span>撤销</h4>
			<p>撤销入口在 菜单栏力的 “编辑” 中的 “撤销”，也可使用快捷键Ctrl+Z：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-57.4pt">1.8.13.2<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span>重做</h4>
			<p>重做入口在 菜单栏力的 “编辑” 中的 “重做”，也可使用快捷键Ctrl+Y：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-57.4pt">1.8.13.3<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span>剪切</h4>
			<p>剪切入口在 菜单栏力的 “编辑” 中的 “剪切”，也可使用快捷键Ctrl+X：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.4<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>复制</h4>
			<p>复制入口在 菜单栏力的 “编辑” 中的 “复制”，也可使用快捷键Ctrl+C：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.5<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>粘贴</h4>
			<p>粘贴入口在 菜单栏力的 “编辑” 中的 “粘贴”，也可使用快捷键Ctrl+V：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.6<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>查找并替换</h4>
			<p>查找并替换入口在 菜单栏力的 “编辑” 中的 “查找并替换”，也可使用快捷键Ctrl+F：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">点击后会出现：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.197.jpg" width="475" height="399" alt="" />
			</p>
			<ol type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:42pt; text-indent:0pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">查询：</span></li>
			</ol>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">在 “查找(F):” 框中输入需要查找的字段，点击查找 ”(N)” 查询，</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">二、查询条件：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">1、方向：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">向前： 往当前对象之前查找</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">向后： 往当前对象之后查找</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">2、作用域：</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">全部：查询SQL编辑器中的所有字段</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">选择的行： 查询鼠标选中的字段</p>
			<ol start="3" type="1" style="margin:0pt; padding-left:0pt">
				<li style="margin-left:21pt; text-indent:21pt; line-height:150%; font-family:Calibri; font-size:10.5pt; list-style-position:inside"><span style="font-family:宋体; font-size:10.5pt">选项：</span></li>
			</ol>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">区分大小写：区分大小写</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">循环搜索：从当前对象查询到末尾，会重头查询</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:12pt"><span style="font-size:10.5pt">全字匹配：查</span><span style="font-size:12pt">找完全匹配的完整的词</span></p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">增量：随着上面查找输入，会自动查找，比如先查a,输入a,编辑器找到a,再输入b,则查找到ab</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">正则匹配：通过正则表达式查询</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt">三、替换：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">在 “替换为(E)”框中输入替换为的字段，</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt"> 点击 “替换(R)” ，替换当前地段，</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt"> 点击 “替换/查找(D)” ，替换当前字段并查找下一个查找对象，</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt"> 点击 “全部替换(A)”，替换所有匹配对象。</p>
			<p style="text-indent:0pt; line-height:150%; font-size:10.5pt">&#xa0;</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.7<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>查找下一个</h4>
			<p>查找下一个入口在 菜单栏力的 “编辑” 中的 “查找下一个”，也可使用快捷键Ctrl+K：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.8<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>查找上一个</h4>
			<p>查找上一个入口在 菜单栏力的 “编辑” 中的 “查找上一个”，也可使用快捷键Ctrl+Shift+K：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.9<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>添加行注释</h4>
			<p>添加行注释入口在 菜单栏力的 “编辑” 中的 “添加行注释”：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">点击后在编辑器行中，会添加注释：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.198.jpg" width="538" height="214" alt="" />
			</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">&#xa0;</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.10<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>添加块注释</h4>
			<p>添加块注释入口在 菜单栏力的 “编辑” 中的 “添加块注释”：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">在SQL编辑器中选中需要注释的字段，点击该按钮后，如图：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.199.jpg" width="598" height="207" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.11<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>自动换行</h4>
			<p>自动换行入口在 菜单栏力的 “编辑” 中的 “自动换行”：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">当输入Sql语句超出边界时，会转到下一行中输入。</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.12<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>更改为大写</h4>
			<p>更改为大写入口在 菜单栏力的 “编辑” 中的 “更改为大写”，也可使用快捷键Ctrl+Shift+X：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<h4 style="margin-left:57.4pt; text-indent:-43.2pt">1.8.13.13<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0;&#xa0;&#xa0; </span>更改为小写</h4>
			<p>更改为小写入口在 菜单栏力的 “编辑” 中的 “更改为小写”，也可使用快捷键Ctrl+Shift+Y：</p>
			<p style="margin-left:42pt; text-indent:0pt; line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.196.jpg" width="346" height="382" alt="" />
			</p>
			<!-- -------------------------- -->
			<h3 style="margin-left:42.55pt; text-indent:-42.55pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.8.14</span><span style="font:7.0pt 'Times New Roman'"> </span><a name="_Toc443396615">表字段</a></h3>
			<p style="line-height:150%; font-size:10.5pt">SQL编辑器可通过选中表名，在右键菜单中选择表字段来选取当前表的字段，还通过shift键、ctrl键实现多选，拖动选中的表字段添加到SQL编辑器中。</p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt"><img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.clickTableField.png" width="330" height="240" alt="" /></p>
			<p></p>
			<p style="margin-left:21pt; line-height:150%; font-size:10.5pt"><img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.showTableField.png" width="528" height="216" alt="" /></p>
			<!--<p style="line-height:150%; font-size:10.5pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.158.jpg" width="295" height="341" alt="" />
			</p>-->
			<!-- -------------------------- -->
			
			<p>&#xa0;</p>
			
			</body>
</html>